Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NLS_DATE_LANGUAGE

Property | Description
--- | ---
Parameter type | String
Syntax | `NLS_DATE_LANGUAGE =` `language`
Default value | Derived from `NLS_LANGUAGE`
Modifiable | `ALTER SESSION`
Range of values | Any valid `NLS_LANGUAGE` value

`NLS_DATE_LANGUAGE` specifies the language to use for the spelling of day and month names and date abbreviations (a.m., p.m., AD, BC) returned by the `TO_DATE` and `TO_CHAR` functions.

See Also: Oracle Database Globalization Support Guide for more information on setting this parameter Oracle Database SQL Reference for information on the `TO_DATE` and `TO_CHAR` functions. Oracle Database Heterogeneous Connectivity Administrator's Guide for information on setting this parameter in heterogeneous systems